WorkstationTenderHistory

Entity Definition

Logical Name : WorkstationTenderHistory
Physical Name : LE_HST_WS_TND

A collection of tender type accumulators by WORKSTATION for a REPORTING PERIOD. This entity is used to support workstation tender accountability.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
WorkstationID (FK)(PK) The unique identifier for the WORKSTATION, typically the serial number. ID_WS Identity integer WorkstationHistory(LE_HST_WS)
WorkstationAccumulator (FK)(PK) A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. TY_TND Code varchar(20) Tender(AS_TND)
ReportingPeriodID (FK)(PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer WorkstationHistory(LE_HST_WS)
TotalTenderMediaCount The total number of tender pickup media units recorded by WORKSTATION for each REPORTING PERIOD. QU_MD_TND_TOT QuantityTransactionCount decimal(7,0)
TotalTenderMediaOverCount The total number of tender media unit overages recorded by WORKSTATION for each REPORTING PERIOD. QU_MD_TND_OVR_TOT QuantityTransactionCount decimal(7,0)
TotalTenderMediaShortCount The total number of tender media unit shortages recorded by WORKSTATION for each REPORTING PERIOD. QU_MD_TND_SHRT_TOT QuantityTransactionCount decimal(7,0)
TotalBeginningTenderMediaUnitCount The opening balance of the number of tender media units for that WORKSTATION for each REPORTING PERIOD. QU_MD_BGN_TND QuantityTransactionCount decimal(7,0)
TotalTenderLoanMediaUnitCount The total number of tender loan media units collected from WORKSTATION for each REPORTING PERIOD. QU_MD_TND_LN_TOT QuantityTransactionCount decimal(7,0)
LoanMediaTotalAmount The total monetary value of tender media loans recorded by WORKSTATION for each REPORTING PERIOD. CP_MD_TND_LON_TOT Money decimal(16,5)
TotalTenderPickupMediaUnitCount The total number of tender pickup media units recorded by WORKSTATION for each REPORTING PERIOD. QU_MD_TND_PKP_TOT QuantityTransactionCount decimal(7,0)
PickupMediaTotalAmount The total monetary value of tender media pickups recorded by WORKSTATION for each REPORTING PERIOD. CP_MD_TND_PKP_TOT Money decimal(16,5)
DepositTotalAmount The total monetary value of tender pickup media recorded by WORKSTATION for each REPORTING PERIOD. CP_DS_TND_TOT Money decimal(16,5)
DepositMediaUnitCount The total number of tender media units deposited on behalf of that WORKSTATION for each REPORTING PERIOD. QU_MD_TND_DS_TOT QuantityTransactionCount decimal(7,0)
OverTotalAmount The total monetary value of tender overages recorded by WORKSTATION for each REPORTING PERIOD. CP_TND_OVR_TOT Money decimal(16,5)
ShortTotalAmount The total monetary value of tender underages recorded for that WORKSTATION for each REPORTING PERIOD. CP_TND_SHRT_TOT Money decimal(16,5)

Relationships

Parent Entity Verb Phrase Child Entity
WorkstationHistory includes WorkstationTenderHistory
Tender is tracked by WorkstationTenderHistory

Logical Views containing WorkstationTenderHistory

Logical View
Logical 03100 - Reporting - Store Operations - Macro View
Logical 03120 - Reporting - Store Operations - Period View
Logical 03140 - Reporting - Store Operations - Workstation View